﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="view_list_reservation.aspx.cs" Inherits="view_list_reservation" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">


<div align="center">
<br /><br />
        <img src="Image/view-list-reservation.png" alt=""/><br /><br /><br />

    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
        AllowSorting="True" AutoGenerateColumns="False"
        ForeColor="#FFCC66" BorderColor="#4A1106" DataSourceID="orclDataSource1" PageSize="20" 
        >
        <Columns>
            <asp:BoundField DataField="GUEST_ID" HeaderText="GUEST_ID" 
                SortExpression="GUEST_ID" />
            <asp:BoundField DataField="ROOM_NO" HeaderText="ROOM_NO" 
                SortExpression="ROOM_NO" />
            <asp:BoundField DataField="STAFF_ID" HeaderText="STAFF_ID" 
                SortExpression="STAFF_ID" />
            <asp:BoundField DataField="CHECKIN_DATE" HeaderText="CHECKIN_DATE" 
                SortExpression="CHECKIN_DATE" />
            <asp:BoundField DataField="CHECKOUT_DATE" HeaderText="CHECKOUT_DATE" 
                SortExpression="CHECKOUT_DATE" />
            <asp:BoundField DataField="STATUS" HeaderText="STATUS" 
                SortExpression="STATUS" />
        </Columns>
        <HeaderStyle BackColor="#993300" />
        <PagerStyle HorizontalAlign="Center" />
        <RowStyle HorizontalAlign="Center" />
    </asp:GridView>

        <asp:SqlDataSource ID="orclDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionString25 %>" 
        ProviderName="<%$ ConnectionStrings:ConnectionString25.ProviderName %>" 
        SelectCommand="SELECT GUEST_ID, ROOM_NO, STAFF_ID, CHECKIN_DATE, CHECKOUT_DATE, STATUS FROM RESERVATIONS">
    </asp:SqlDataSource>

        <br />
            <asp:Button ID="Button5" runat="server" BackColor="#FFCC66" 
                BorderColor="#FF9966" Height="25px" onclick="Back_Click" Text="&lt;&lt; Back" 
                Width="85px" />

</div>



</asp:Content>

